package com.example.mypotiota_si.Sqlitedates;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import androidx.annotation.Nullable;

public class Shop_Shopping_cart_cache extends SQLiteOpenHelper {

    public static final String SHOP_SQLITE_DATES_NAME="shoping_cart_cache" ;
    public static final String SHOP_SQLITE_DATES_ID="_id" ;


    public static final String SHOP_SQLITE_DATES_DT_PIC="pic" ;
    public static final String SHOP_SQLITE_DATES_DT_NAME="name" ;
    public static final String SHOP_SQLITE_DATES_DT_YUESHOU="yueshou" ;
    public static final String SHOP_SQLITE_DATES_DT_IMAGER_ADDRESS="imager_address" ;
    public static final String SHOP_SQLITE_DATES_DT_NUMBER="numbers" ;
    public static final String SHOP_SQLITE_SQL="create table "+SHOP_SQLITE_DATES_NAME+" ( "+SHOP_SQLITE_DATES_ID+" integer primary key AUTOINCREMENT , "+SHOP_SQLITE_DATES_DT_PIC+
            " TEXT NOT NULL ,"+SHOP_SQLITE_DATES_DT_NAME+
            " TEXT NOT NULL ,"+SHOP_SQLITE_DATES_DT_YUESHOU+
            " TEXT NOT NULL ,"+SHOP_SQLITE_DATES_DT_IMAGER_ADDRESS+
            " TEXT NOT NULL ,"+SHOP_SQLITE_DATES_DT_NUMBER+
            " TEXT NOT NULL )" ;


    public Shop_Shopping_cart_cache(@Nullable Context context) {
        super(context, "Shopping_cart_cache", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(SHOP_SQLITE_SQL);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}
